package com.ak.db;

import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;

import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.NameValuePair;
import org.apache.http.client.HttpClient;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.DefaultHttpClient;
import org.apache.http.message.BasicNameValuePair;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.widget.LinearLayout;
import android.widget.TextView;
import android.widget.Toast;

public class akdb extends Activity {
    /** Called when the activity is first created. */
	//public static final String KEY_121 = "http://yangjustine.startlogic.com/appkudos/dbRetrieveEg.php"; 
	public static final String KEY_121 = "http://yangjustine.startlogic.com/appkudos/dbInsertEg.php";
	//public static final String KEY_121 = "http://yangjustine.startlogic.com/appkudos/dbRetrieveMultiple.php";
//    public static final String TESTURL = "http://www.justineyang.com";
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        TextView txt = (TextView) this.findViewById(R.id.hello);
	    txt.setText("Connecting...");
	    txt.setText(getServerData(KEY_121));
    }
    
	private String getServerData(String returnString) {
	   
	   InputStream is = null;
	   
	   String result = "";
	    //the year data to send
	    ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
	    nameValuePairs.add(new BasicNameValuePair("username","testuser5"));
	    nameValuePairs.add(new BasicNameValuePair("firstname","test"));
	    nameValuePairs.add(new BasicNameValuePair("lastname","user5"));
	    //http post
	    try{
	            HttpClient httpclient = new DefaultHttpClient();          
	            HttpPost httppost = new HttpPost(KEY_121);           
	            httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));            
	            HttpResponse response = httpclient.execute(httppost);	           
	            HttpEntity entity = response.getEntity();
	            is = entity.getContent();	          
	
	    }catch(Exception e){
//	    	    test = "Error in http connection "+e.toString();
	            Log.e("log_tag", "Error in http connection "+e.toString());
	    }
		
	    //convert response to string
	    try{
	            BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
	            StringBuilder sb = new StringBuilder();
	            String line = null;
	            while ((line = reader.readLine()) != null) {
	                    sb.append(line + "\n");
	            }
	            is.close();
	            result=sb.toString();
	    }catch(Exception e){
	            Log.e("log_tag", "Error converting result "+e.toString());
	    }
	    //parse json data
	    try{
	            JSONArray jArray = new JSONArray(result);
	            for(int i=0;i<jArray.length();i++){
	                    JSONObject json_data = jArray.getJSONObject(i);
	                    Log.i("log_tag","username: "+json_data.getString("username")+
	                            ", firstname: "+json_data.getString("firstname")+
	                            ", lastname: "+json_data.getInt("lastname")
	                    );
	                    //Get an output to the screen
	                    returnString += "\n\t" + jArray.getJSONObject(i);
	                    
	            }
	    }catch(JSONException e){
	            Log.e("log_tag", "Error parsing data "+e.toString());
	    }

	    
	    return result;
	}     
}